package com.xiaowu.mapper;

import com.xiaowu.pojo.Blind;
import com.xiaowu.pojo.Communit;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface CommunitMapper {
    //划船社区
    @Select("select userId, Id, sendMsgTime, sendMsg, isSendByBlind from boatingcommunitymsg")
    List<Communit> boatlist();

    //骑行社区
    @Select("select userId, Id, sendMsgTime, sendMsg, isSendByBlind from cyclingcommunitymsg")
    List<Communit> cyclelist();
    //饮食健康
    @Select("select userId, Id, sendMsgTime, sendMsg, isSendByBlind from eat_healthilycommunitymsg")
    List<Communit> healthlist();
    //娱乐社区
    @Select("select userId, Id, sendMsgTime, sendMsg, isSendByBlind from entertainmentcommunitymsg")
    List<Communit> etmlist();
    //药品社区
    @Select("select userId, Id, sendMsgTime, sendMsg, isSendByBlind from medicinecommunitymsg")
    List<Communit> medicallist();
    //登山社区
    @Select("select userId, Id, sendMsgTime, sendMsg, isSendByBlind from mountain_climbingcommunitymsg")
    List<Communit> climblist();
    //电影社区
    @Select("select userId, Id, sendMsgTime, sendMsg, isSendByBlind from moviecommunitymsg")
    List<Communit> movielist();
    //自驾游社区
    @Select("select userId, Id, sendMsgTime, sendMsg, isSendByBlind from self_drive_tourcommunitymsg")
    List<Communit> drivelist();
}
